home *** CD-ROM | disk | FTP | other *** search
/ PC World 2007 December / PCWorld_2007-12_cd.bin / domacnost a kancelar / autoit / autoit-v3-setup.exe / Examples / Helpfile / _SQLite_Changes.au3 < prev    next >
Text File  |  2007-09-08  |  476b  |  13 lines
  1. #include <SQLite.au3>
  2. #include <SQLite.dll.au3>
  3.  
  4. _SQLite_Startup()
  5. _SQLite_Open()
  6. _SQLite_Exec(-1,"CREATE TABLE test (a, b);") ; Create Table
  7. _SQLite_Exec(-1,"INSERT INTO test VALUES ('1', '2');") ; Insert Row 1
  8. _SQLite_Exec(-1,"INSERT INTO test VALUES ('3', '4');") ; Insert Row 2
  9. MsgBox(0,"SQLite","The Last Query changed " & _SQLite_Changes() & " Rows" & @CR & _
  10.                   "All Query changed " & _SQLite_TotalChanges() & " Rows")
  11. _SQLite_Close()
  12. _SQLite_Shutdown()
  13.